﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace FortuneHeavenCommon.DataMap
{
    public partial class UserInfor
    {
        public const string TABLE_NAME = "UserInfor";
        public const string INSERT_SQL = "insert into UserInfor([ID],[UserID],[ShowImg],[RegisterQuestion],[RegisterAnswer],[RegisterEmail],[IDCard],[Portrait],[FortuneValue],[FaceID],[QQ],[MSN],[Birthday],[Province],[City],[NickName],[SpreadValue],[IsSpread],[IsSpRegister],[FromPage]) values (@ID,@UserID,@ShowImg,@RegisterQuestion,@RegisterAnswer,@RegisterEmail,@IDCard,@Portrait,@FortuneValue,@FaceID,@QQ,@MSN,@Birthday,@Province,@City,@NickName,@SpreadValue,@IsSpread,@IsSpRegister,@FromPage)";
        public const string UPDATE_SQL = "UPDATE UserInfor SET [ID]=@ID,[UserID]=@UserID,[ShowImg]=@ShowImg,[RegisterQuestion]=@RegisterQuestion,[RegisterAnswer]=@RegisterAnswer,[RegisterEmail]=@RegisterEmail,[IDCard]=@IDCard,[Portrait]=@Portrait,[FortuneValue]=@FortuneValue,[FaceID]=@FaceID,[QQ]=@QQ,[MSN]=@MSN,[Birthday]=@Birthday,[Province]=@Province,[City]=@City,[NickName]=@NickName,[SpreadValue]=@SpreadValue,[IsSpread]=@IsSpread,[IsSpRegister]=@IsSpRegister,[FromPage]=@FromPage where ID = @ID";

        /// <summary>
        ///
        /// </summary>
        public int ID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int UserID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string ShowImg
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string RegisterQuestion
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string RegisterAnswer
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string RegisterEmail
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string IDCard
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string Portrait
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public double FortuneValue
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int FaceID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string QQ
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string MSN
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public DateTime Birthday
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string Province
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string City
        {
            get;
            set;
        }

        public string NickName
        {
            get;
            set;
        }

        public int SpreadValue
        {
            get;
            set;
        }

        public int IsSpread
        {
            get;
            set;
        }

        public int IsSpRegister
        {
            get;
            set;
        }

        public string FromPage
        {
            get;
            set;
        }
    }


}
